In [5]:
pip install --upgrade pip
Requirement already satisfied: pip in c:\users\par20\anaconda3\lib\site-packages (21.0.1)
Collecting pip
  Downloading pip-22.3-py3-none-any.whl (2.1 MB)
Installing collected packages: pip
  Attempting uninstall: pip
    Found existing installation: pip 21.0.1
    Uninstalling pip-21.0.1:
      Successfully uninstalled pip-21.0.1
Successfully installed pip-22.3
Note: you may need to restart the kernel to use updated packages.
In [8]:
pip install Pandas-Profiling
Collecting Pandas-Profiling
  Downloading pandas_profiling-3.3.0-py2.py3-none-any.whl (268 kB)
     -------------------------------------- 268.0/268.0 kB 4.2 MB/s eta 0:00:00
Requirement already satisfied: matplotlib<3.6,>=3.2 in c:\users\par20\anaconda3\lib\site-packages (from Pandas-Profiling) (3.3.4)
Collecting joblib~=1.1.0
  Downloading joblib-1.1.1-py2.py3-none-any.whl (309 kB)
     -------------------------------------- 309.8/309.8 kB 4.8 MB/s eta 0:00:00
Requirement already satisfied: pandas!=1.4.0,<1.5,>1.1 in c:\users\par20\anaconda3\lib\site-packages (from Pandas-Profiling) (1.2.4)
Collecting htmlmin==0.1.12
  Downloading htmlmin-0.1.12.tar.gz (19 kB)
  Preparing metadata (setup.py): started
  Preparing metadata (setup.py): finished with status 'done'
Collecting tangled-up-in-unicode==0.2.0
  Downloading tangled_up_in_unicode-0.2.0-py3-none-any.whl (4.7 MB)
     ---------------------------------------- 4.7/4.7 MB 5.2 MB/s eta 0:00:00
Collecting missingno<0.6,>=0.4.2
  Downloading missingno-0.5.1-py3-none-any.whl (8.7 kB)
Requirement already satisfied: seaborn<0.12,>=0.10.1 in c:\users\par20\anaconda3\lib\site-packages (from Pandas-Profiling) (0.11.1)
Requirement already satisfied: tqdm<4.65,>=4.48.2 in c:\users\par20\anaconda3\lib\site-packages (from Pandas-Profiling) (4.59.0)
Collecting pydantic<1.10,>=1.8.1
  Downloading pydantic-1.9.2-cp38-cp38-win_amd64.whl (2.1 MB)
     ---------------------------------------- 2.1/2.1 MB 5.0 MB/s eta 0:00:00
Collecting multimethod<1.9,>=1.4
  Downloading multimethod-1.8-py3-none-any.whl (9.8 kB)
Requirement already satisfied: requests<2.29,>=2.24.0 in c:\users\par20\anaconda3\lib\site-packages (from Pandas-Profiling) (2.25.1)
Requirement already satisfied: jinja2<3.2,>=2.11.1 in c:\users\par20\anaconda3\lib\site-packages (from Pandas-Profiling) (2.11.3)
Collecting visions[type_image_path]==0.7.5
  Downloading visions-0.7.5-py3-none-any.whl (102 kB)
     -------------------------------------- 102.7/102.7 kB 6.2 MB/s eta 0:00:00
Collecting phik<0.13,>=0.11.1
  Downloading phik-0.12.2-cp38-cp38-win_amd64.whl (677 kB)
     -------------------------------------- 677.3/677.3 kB 4.8 MB/s eta 0:00:00
Collecting statsmodels<0.14,>=0.13.2
  Downloading statsmodels-0.13.2-cp38-cp38-win_amd64.whl (9.1 MB)
     ---------------------------------------- 9.1/9.1 MB 5.1 MB/s eta 0:00:00
Requirement already satisfied: scipy<1.10,>=1.4.1 in c:\users\par20\anaconda3\lib\site-packages (from Pandas-Profiling) (1.6.2)
Requirement already satisfied: PyYAML<6.1,>=5.0.0 in c:\users\par20\anaconda3\lib\site-packages (from Pandas-Profiling) (5.4.1)
Requirement already satisfied: numpy<1.24,>=1.16.0 in c:\users\par20\anaconda3\lib\site-packages (from Pandas-Profiling) (1.20.1)
Requirement already satisfied: networkx>=2.4 in c:\users\par20\anaconda3\lib\site-packages (from visions[type_image_path]==0.7.5->Pandas-Profiling) (2.5)
Requirement already satisfied: attrs>=19.3.0 in c:\users\par20\anaconda3\lib\site-packages (from visions[type_image_path]==0.7.5->Pandas-Profiling) (20.3.0)
Collecting imagehash
  Downloading ImageHash-4.3.1-py2.py3-none-any.whl (296 kB)
     -------------------------------------- 296.5/296.5 kB 2.3 MB/s eta 0:00:00
Requirement already satisfied: Pillow in c:\users\par20\anaconda3\lib\site-packages (from visions[type_image_path]==0.7.5->Pandas-Profiling) (8.2.0)
Requirement already satisfied: MarkupSafe>=0.23 in c:\users\par20\anaconda3\lib\site-packages (from jinja2<3.2,>=2.11.1->Pandas-Profiling) (1.1.1)
Requirement already satisfied: kiwisolver>=1.0.1 in c:\users\par20\anaconda3\lib\site-packages (from matplotlib<3.6,>=3.2->Pandas-Profiling) (1.3.1)
Requirement already satisfied: cycler>=0.10 in c:\users\par20\anaconda3\lib\site-packages (from matplotlib<3.6,>=3.2->Pandas-Profiling) (0.10.0)
Requirement already satisfied: python-dateutil>=2.1 in c:\users\par20\anaconda3\lib\site-packages (from matplotlib<3.6,>=3.2->Pandas-Profiling) (2.8.1)
Requirement already satisfied: pyparsing!=2.0.4,!=2.1.2,!=2.1.6,>=2.0.3 in c:\users\par20\anaconda3\lib\site-packages (from matplotlib<3.6,>=3.2->Pandas-Profiling) (2.4.7)
Requirement already satisfied: pytz>=2017.3 in c:\users\par20\anaconda3\lib\site-packages (from pandas!=1.4.0,<1.5,>1.1->Pandas-Profiling) (2021.1)
Requirement already satisfied: typing-extensions>=3.7.4.3 in c:\users\par20\anaconda3\lib\site-packages (from pydantic<1.10,>=1.8.1->Pandas-Profiling) (3.7.4.3)
Requirement already satisfied: certifi>=2017.4.17 in c:\users\par20\anaconda3\lib\site-packages (from requests<2.29,>=2.24.0->Pandas-Profiling) (2020.12.5)
Requirement already satisfied: chardet<5,>=3.0.2 in c:\users\par20\anaconda3\lib\site-packages (from requests<2.29,>=2.24.0->Pandas-Profiling) (4.0.0)
Requirement already satisfied: urllib3<1.27,>=1.21.1 in c:\users\par20\anaconda3\lib\site-packages (from requests<2.29,>=2.24.0->Pandas-Profiling) (1.26.4)
Requirement already satisfied: idna<3,>=2.5 in c:\users\par20\anaconda3\lib\site-packages (from requests<2.29,>=2.24.0->Pandas-Profiling) (2.10)
Collecting packaging>=21.3
  Downloading packaging-21.3-py3-none-any.whl (40 kB)
     ---------------------------------------- 40.8/40.8 kB 1.9 MB/s eta 0:00:00
Collecting patsy>=0.5.2
  Downloading patsy-0.5.3-py2.py3-none-any.whl (233 kB)
     -------------------------------------- 233.8/233.8 kB 2.8 MB/s eta 0:00:00
Requirement already satisfied: six in c:\users\par20\anaconda3\lib\site-packages (from cycler>=0.10->matplotlib<3.6,>=3.2->Pandas-Profiling) (1.15.0)
Requirement already satisfied: decorator>=4.3.0 in c:\users\par20\anaconda3\lib\site-packages (from networkx>=2.4->visions[type_image_path]==0.7.5->Pandas-Profiling) (5.0.6)
Requirement already satisfied: PyWavelets in c:\users\par20\anaconda3\lib\site-packages (from imagehash->visions[type_image_path]==0.7.5->Pandas-Profiling) (1.1.1)
Building wheels for collected packages: htmlmin
  Building wheel for htmlmin (setup.py): started
  Building wheel for htmlmin (setup.py): finished with status 'done'
  Created wheel for htmlmin: filename=htmlmin-0.1.12-py3-none-any.whl size=27085 sha256=cf877cfb86000ae7eab087c0aa30aef0b977fa64327c0ccef9e5c16572441bac
  Stored in directory: c:\users\par20\appdata\local\pip\cache\wheels\28\f3\26\826f91b0c848ff98f1725cd43014a6f3a2d961114157d790db
Successfully built htmlmin
Installing collected packages: htmlmin, tangled-up-in-unicode, pydantic, patsy, packaging, multimethod, joblib, imagehash, visions, statsmodels, phik, missingno, Pandas-Profiling
  Attempting uninstall: patsy
    Found existing installation: patsy 0.5.1
    Uninstalling patsy-0.5.1:
      Successfully uninstalled patsy-0.5.1
  Attempting uninstall: packaging
    Found existing installation: packaging 20.9
    Uninstalling packaging-20.9:
      Successfully uninstalled packaging-20.9
  Attempting uninstall: joblib
    Found existing installation: joblib 1.0.1
    Uninstalling joblib-1.0.1:
      Successfully uninstalled joblib-1.0.1
  Attempting uninstall: statsmodels
    Found existing installation: statsmodels 0.12.2
    Uninstalling statsmodels-0.12.2:
      Successfully uninstalled statsmodels-0.12.2
Successfully installed Pandas-Profiling-3.3.0 htmlmin-0.1.12 imagehash-4.3.1 joblib-1.1.1 missingno-0.5.1 multimethod-1.8 packaging-21.3 patsy-0.5.3 phik-0.12.2 pydantic-1.9.2 statsmodels-0.13.2 tangled-up-in-unicode-0.2.0 visions-0.7.5
Note: you may need to restart the kernel to use updated packages.
In [10]:
import numpy as np
import pandas as pd
from pandas_profiling import ProfileReport
In [13]:
df_Covid19_patient_impact = pd.read_csv("C:/Users/par20/Downloads/COVID-19_Reported_Patient_Impact_and_Hospital_Capacity_by_Facility.csv")
df_Covid19_patient_impact.head()
Out[13]:
hospital_pk collection_week state ccn hospital_name address city zip hospital_subtype fips_code ... previous_day_admission_pediatric_covid_confirmed_unknown_7_day_sum staffed_icu_pediatric_patients_confirmed_covid_7_day_avg staffed_icu_pediatric_patients_confirmed_covid_7_day_coverage staffed_icu_pediatric_patients_confirmed_covid_7_day_sum staffed_pediatric_icu_bed_occupancy_7_day_avg staffed_pediatric_icu_bed_occupancy_7_day_coverage staffed_pediatric_icu_bed_occupancy_7_day_sum total_staffed_pediatric_icu_beds_7_day_avg total_staffed_pediatric_icu_beds_7_day_coverage total_staffed_pediatric_icu_beds_7_day_sum
0 50742 2022-09-09 CA 50742 OLYMPIA MEDICAL CENTER 5900 WEST OLYMPIC BOULEVARD LOS ANGELES 90036.0 Short Term 6037.0 ... NaN NaN 0 NaN NaN 0 NaN NaN 0 NaN
1 360362 2022-09-09 OH 360362 TRIHEALTH EVENDALE HOSPITAL 3155 GLENDALE MILFORD ROAD CINCINNATI 45241.0 Short Term 39061.0 ... 0.0 0.0 7 0.0 0.0 7 0.0 0.0 7 0.0
2 50028 2022-09-02 CA 50028 MAD RIVER COMMUNITY HOSPITAL 3800 JANES RD ARCATA 95521.0 Short Term 6023.0 ... NaN NaN 0 NaN NaN 0 NaN NaN 0 NaN
3 100106 2022-09-02 FL 100106 DOCTORS MEMORIAL HOSPITAL INC 333 N BYRON BUTLER PKWY PERRY 32348.0 Short Term 12123.0 ... 0.0 0.0 7 0.0 0.0 7 0.0 0.0 7 0.0
4 110190 2022-09-02 GA 110190 FLINT RIVER COMMUNITY HOSPITAL 509 SUMTER STREET, BOX 770 MONTEZUMA 31063.0 Short Term 13193.0 ... 0.0 0.0 7 0.0 0.0 7 0.0 0.0 7 0.0

5 rows × 128 columns

In [17]:
profile_minimal = ProfileReport(df_Covid19_patient_impact, title="Pandas Profiling Report", minimal = True)
In [18]:
profile_minimal
Out[18]:

In [ ]: